SAP Business Intelligence Quick Start Guide by Vinay Singh

Author:Vinay Singh [Vinay Singh]
Language: eng
Format: epub
Tags: COM005030 - COMPUTERS / Enterprise Applications / Business Intelligence Tools, COM018000 - COMPUTERS / Data Processing, COM089000 - COMPUTERS / Data Visualization
Publisher: Packt
Published: 2019-02-21T11:54:59+00:00

When we sort, we have the sort direction (ascending or descending), and the object we want the sort to be based on (sort object). Sort objects let you determine the order in which data appears on your report. Almost any object can be used for sorting, including formulas. An object's data type determines how the data from that object is sorted. In single object sorting, all of the records that are used in the report are sorted based on the values in a single object. Sorting an inventory report by stock number or sorting a customer list by customer number are examples of single object sorts. With multiple object sorts, Crystal Reports first sorts the records based on the values in the first object that's selected, putting them in ascending or descending order, as specified. If two or more records have a matching object value in the first sort object, the matching records are sorted by the value in the second sort object. For example, if you choose to sort first by country and then by region, both in ascending order, the report would appear with countries listed in alphabetic order and regions within each country listed in alphabetic order. Any other objects, such as the postal codes within each region, would remain unsorted.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.